{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Создайте датафрейм с клиентами и сохраните его в clients"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "# df = pd.read_csv('kc_house_data.csv', sep=',')\n",
    "df = pd.read_csv(\"https://gbcdn.mrgcdn.ru/uploads/asset/5964767/attachment/6c023c8fce9d5cc694e5d6ce941951ae.csv\", sep=\",\")\n",
    "\n",
    "clients = pd.DataFrame({\n",
    "    'client_id': [1459, 4684, 3498, 3942, 4535, 2308, 2866, 2765, 1472, 4236,\n",
    "                  2295, 939, 3840, 280, 20, 4332, 3475, 4213, 3113, 4809, 2134,\n",
    "                  2242, 2068, 4929, 1384, 1589, 3317, 2260, 1727, 1764, 1611, 1474],\n",
    "    'house_id': [8965450190, 6823100225, 5104540330, 2131701075, 1522700060, 1189000207,\n",
    "                6821600300, 7137950720, 9510920050, 6131600255, 5428000070, 1788800910,\n",
    "                8100400160, 3123049142, 6306800010, 5083000375, 7920100025, 1951600150,\n",
    "                809001400, 339600110, 1622049154, 1099600250, 8563000110, 2768100205,\n",
    "                3995700435, 8861700030, 3303980210, 7731100066, 8146100580, 825069097,\n",
    "                3889100029, 9524100196]\n",
    "})"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Присоедините к таблице clients данные по домам через метод join и сохраните в 'joined'.\n",
    "\n",
    "Данные находятся в файле kc_house_data.csv. Это нужно, чтобы понимать, какие дома покупались клиентами.\n",
    "\n",
    "house_id - это индексы датафрейма с домами."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>client_id</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>bathrooms</th>\n",
       "      <th>sqft_living</th>\n",
       "      <th>sqft_lot</th>\n",
       "      <th>floors</th>\n",
       "      <th>waterfront</th>\n",
       "      <th>view</th>\n",
       "      <th>...</th>\n",
       "      <th>grade</th>\n",
       "      <th>sqft_above</th>\n",
       "      <th>sqft_basement</th>\n",
       "      <th>yr_built</th>\n",
       "      <th>yr_renovated</th>\n",
       "      <th>zipcode</th>\n",
       "      <th>lat</th>\n",
       "      <th>long</th>\n",
       "      <th>sqft_living15</th>\n",
       "      <th>sqft_lot15</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>house_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8965450190</th>\n",
       "      <td>1459</td>\n",
       "      <td>20150218T000000</td>\n",
       "      <td>295000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1500</td>\n",
       "      <td>3060</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1500</td>\n",
       "      <td>0</td>\n",
       "      <td>1994</td>\n",
       "      <td>0</td>\n",
       "      <td>98006</td>\n",
       "      <td>47.5605</td>\n",
       "      <td>-122.117</td>\n",
       "      <td>2700</td>\n",
       "      <td>7734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6823100225</th>\n",
       "      <td>4684</td>\n",
       "      <td>20150414T000000</td>\n",
       "      <td>700000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1870</td>\n",
       "      <td>6000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1670</td>\n",
       "      <td>200</td>\n",
       "      <td>1949</td>\n",
       "      <td>0</td>\n",
       "      <td>98199</td>\n",
       "      <td>47.6435</td>\n",
       "      <td>-122.399</td>\n",
       "      <td>1710</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5104540330</th>\n",
       "      <td>3498</td>\n",
       "      <td>20150508T000000</td>\n",
       "      <td>679000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.50</td>\n",
       "      <td>3680</td>\n",
       "      <td>7236</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>3680</td>\n",
       "      <td>0</td>\n",
       "      <td>2006</td>\n",
       "      <td>0</td>\n",
       "      <td>98038</td>\n",
       "      <td>47.3543</td>\n",
       "      <td>-122.005</td>\n",
       "      <td>3310</td>\n",
       "      <td>7180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2131701075</th>\n",
       "      <td>3942</td>\n",
       "      <td>20141204T000000</td>\n",
       "      <td>420000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1720</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1720</td>\n",
       "      <td>0</td>\n",
       "      <td>1932</td>\n",
       "      <td>2009</td>\n",
       "      <td>98019</td>\n",
       "      <td>47.7380</td>\n",
       "      <td>-121.983</td>\n",
       "      <td>1410</td>\n",
       "      <td>8300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1522700060</th>\n",
       "      <td>4535</td>\n",
       "      <td>20140624T000000</td>\n",
       "      <td>518000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.75</td>\n",
       "      <td>2520</td>\n",
       "      <td>14021</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>2520</td>\n",
       "      <td>0</td>\n",
       "      <td>1999</td>\n",
       "      <td>0</td>\n",
       "      <td>98019</td>\n",
       "      <td>47.7344</td>\n",
       "      <td>-121.957</td>\n",
       "      <td>2330</td>\n",
       "      <td>14007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1189000207</th>\n",
       "      <td>2308</td>\n",
       "      <td>20141021T000000</td>\n",
       "      <td>387000.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1170</td>\n",
       "      <td>1394</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1170</td>\n",
       "      <td>0</td>\n",
       "      <td>2001</td>\n",
       "      <td>0</td>\n",
       "      <td>98122</td>\n",
       "      <td>47.6131</td>\n",
       "      <td>-122.297</td>\n",
       "      <td>1250</td>\n",
       "      <td>3136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6821600300</th>\n",
       "      <td>2866</td>\n",
       "      <td>20150318T000000</td>\n",
       "      <td>886000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.25</td>\n",
       "      <td>2380</td>\n",
       "      <td>6000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>1650</td>\n",
       "      <td>730</td>\n",
       "      <td>1931</td>\n",
       "      <td>0</td>\n",
       "      <td>98199</td>\n",
       "      <td>47.6472</td>\n",
       "      <td>-122.393</td>\n",
       "      <td>2000</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7137950720</th>\n",
       "      <td>2765</td>\n",
       "      <td>20150304T000000</td>\n",
       "      <td>339100.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2350</td>\n",
       "      <td>10655</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>2350</td>\n",
       "      <td>0</td>\n",
       "      <td>1992</td>\n",
       "      <td>0</td>\n",
       "      <td>98092</td>\n",
       "      <td>47.3284</td>\n",
       "      <td>-122.171</td>\n",
       "      <td>2210</td>\n",
       "      <td>7028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9510920050</th>\n",
       "      <td>1472</td>\n",
       "      <td>20140902T000000</td>\n",
       "      <td>725000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2980</td>\n",
       "      <td>16996</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>2980</td>\n",
       "      <td>0</td>\n",
       "      <td>1992</td>\n",
       "      <td>0</td>\n",
       "      <td>98075</td>\n",
       "      <td>47.5950</td>\n",
       "      <td>-122.016</td>\n",
       "      <td>2980</td>\n",
       "      <td>15438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6131600255</th>\n",
       "      <td>4236</td>\n",
       "      <td>20141222T000000</td>\n",
       "      <td>202500.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1540</td>\n",
       "      <td>8316</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1540</td>\n",
       "      <td>0</td>\n",
       "      <td>1954</td>\n",
       "      <td>0</td>\n",
       "      <td>98002</td>\n",
       "      <td>47.3230</td>\n",
       "      <td>-122.216</td>\n",
       "      <td>1250</td>\n",
       "      <td>8316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5428000070</th>\n",
       "      <td>2295</td>\n",
       "      <td>20150511T000000</td>\n",
       "      <td>770000.0</td>\n",
       "      <td>5</td>\n",
       "      <td>3.50</td>\n",
       "      <td>4750</td>\n",
       "      <td>8234</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>3350</td>\n",
       "      <td>1400</td>\n",
       "      <td>2013</td>\n",
       "      <td>0</td>\n",
       "      <td>98198</td>\n",
       "      <td>47.3574</td>\n",
       "      <td>-122.318</td>\n",
       "      <td>2160</td>\n",
       "      <td>14496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1788800910</th>\n",
       "      <td>939</td>\n",
       "      <td>20141020T000000</td>\n",
       "      <td>190000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1200</td>\n",
       "      <td>10458</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1200</td>\n",
       "      <td>0</td>\n",
       "      <td>1961</td>\n",
       "      <td>0</td>\n",
       "      <td>98023</td>\n",
       "      <td>47.3262</td>\n",
       "      <td>-122.342</td>\n",
       "      <td>1160</td>\n",
       "      <td>9000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8100400160</th>\n",
       "      <td>3840</td>\n",
       "      <td>20150413T000000</td>\n",
       "      <td>700000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.25</td>\n",
       "      <td>2330</td>\n",
       "      <td>11424</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>2330</td>\n",
       "      <td>0</td>\n",
       "      <td>1984</td>\n",
       "      <td>0</td>\n",
       "      <td>98052</td>\n",
       "      <td>47.6386</td>\n",
       "      <td>-122.110</td>\n",
       "      <td>2050</td>\n",
       "      <td>11448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3123049142</th>\n",
       "      <td>280</td>\n",
       "      <td>20140805T000000</td>\n",
       "      <td>452000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.25</td>\n",
       "      <td>2600</td>\n",
       "      <td>14810</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1490</td>\n",
       "      <td>1110</td>\n",
       "      <td>1956</td>\n",
       "      <td>0</td>\n",
       "      <td>98166</td>\n",
       "      <td>47.4326</td>\n",
       "      <td>-122.341</td>\n",
       "      <td>2450</td>\n",
       "      <td>16715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6306800010</th>\n",
       "      <td>20</td>\n",
       "      <td>20140811T000000</td>\n",
       "      <td>436472.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2692</td>\n",
       "      <td>8392</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>2692</td>\n",
       "      <td>0</td>\n",
       "      <td>2014</td>\n",
       "      <td>0</td>\n",
       "      <td>98030</td>\n",
       "      <td>47.3519</td>\n",
       "      <td>-122.197</td>\n",
       "      <td>2574</td>\n",
       "      <td>14446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5083000375</th>\n",
       "      <td>4332</td>\n",
       "      <td>20141027T000000</td>\n",
       "      <td>170000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1310</td>\n",
       "      <td>9529</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1310</td>\n",
       "      <td>0</td>\n",
       "      <td>1956</td>\n",
       "      <td>0</td>\n",
       "      <td>98198</td>\n",
       "      <td>47.4105</td>\n",
       "      <td>-122.295</td>\n",
       "      <td>1330</td>\n",
       "      <td>9529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5083000375</th>\n",
       "      <td>4332</td>\n",
       "      <td>20150319T000000</td>\n",
       "      <td>235000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1310</td>\n",
       "      <td>9529</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1310</td>\n",
       "      <td>0</td>\n",
       "      <td>1956</td>\n",
       "      <td>0</td>\n",
       "      <td>98198</td>\n",
       "      <td>47.4105</td>\n",
       "      <td>-122.295</td>\n",
       "      <td>1330</td>\n",
       "      <td>9529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7920100025</th>\n",
       "      <td>3475</td>\n",
       "      <td>20150427T000000</td>\n",
       "      <td>450000.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1.00</td>\n",
       "      <td>740</td>\n",
       "      <td>5100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>740</td>\n",
       "      <td>0</td>\n",
       "      <td>1947</td>\n",
       "      <td>0</td>\n",
       "      <td>98115</td>\n",
       "      <td>47.6787</td>\n",
       "      <td>-122.301</td>\n",
       "      <td>920</td>\n",
       "      <td>5100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1951600150</th>\n",
       "      <td>4213</td>\n",
       "      <td>20150408T000000</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1610</td>\n",
       "      <td>8500</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1610</td>\n",
       "      <td>0</td>\n",
       "      <td>1959</td>\n",
       "      <td>0</td>\n",
       "      <td>98032</td>\n",
       "      <td>47.3717</td>\n",
       "      <td>-122.297</td>\n",
       "      <td>1070</td>\n",
       "      <td>8750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809001400</th>\n",
       "      <td>3113</td>\n",
       "      <td>20140922T000000</td>\n",
       "      <td>925000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1630</td>\n",
       "      <td>3200</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1630</td>\n",
       "      <td>0</td>\n",
       "      <td>1912</td>\n",
       "      <td>0</td>\n",
       "      <td>98109</td>\n",
       "      <td>47.6351</td>\n",
       "      <td>-122.352</td>\n",
       "      <td>1710</td>\n",
       "      <td>3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339600110</th>\n",
       "      <td>4809</td>\n",
       "      <td>20140923T000000</td>\n",
       "      <td>395000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1610</td>\n",
       "      <td>3755</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1610</td>\n",
       "      <td>0</td>\n",
       "      <td>1987</td>\n",
       "      <td>0</td>\n",
       "      <td>98052</td>\n",
       "      <td>47.6825</td>\n",
       "      <td>-122.097</td>\n",
       "      <td>1300</td>\n",
       "      <td>3823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1622049154</th>\n",
       "      <td>2134</td>\n",
       "      <td>20141215T000000</td>\n",
       "      <td>289900.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1899</td>\n",
       "      <td>11325</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1899</td>\n",
       "      <td>0</td>\n",
       "      <td>1943</td>\n",
       "      <td>2005</td>\n",
       "      <td>98198</td>\n",
       "      <td>47.3987</td>\n",
       "      <td>-122.300</td>\n",
       "      <td>2000</td>\n",
       "      <td>10454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1099600250</th>\n",
       "      <td>2242</td>\n",
       "      <td>20141202T000000</td>\n",
       "      <td>260000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1710</td>\n",
       "      <td>6400</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1240</td>\n",
       "      <td>470</td>\n",
       "      <td>1976</td>\n",
       "      <td>0</td>\n",
       "      <td>98023</td>\n",
       "      <td>47.3036</td>\n",
       "      <td>-122.377</td>\n",
       "      <td>1600</td>\n",
       "      <td>6400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8563000110</th>\n",
       "      <td>2068</td>\n",
       "      <td>20150424T000000</td>\n",
       "      <td>427000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1460</td>\n",
       "      <td>9750</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1460</td>\n",
       "      <td>0</td>\n",
       "      <td>1967</td>\n",
       "      <td>0</td>\n",
       "      <td>98008</td>\n",
       "      <td>47.6205</td>\n",
       "      <td>-122.102</td>\n",
       "      <td>1820</td>\n",
       "      <td>9840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2768100205</th>\n",
       "      <td>4929</td>\n",
       "      <td>20140625T000000</td>\n",
       "      <td>519000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1950</td>\n",
       "      <td>2617</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1250</td>\n",
       "      <td>700</td>\n",
       "      <td>1910</td>\n",
       "      <td>0</td>\n",
       "      <td>98107</td>\n",
       "      <td>47.6696</td>\n",
       "      <td>-122.372</td>\n",
       "      <td>1520</td>\n",
       "      <td>1438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3995700435</th>\n",
       "      <td>1384</td>\n",
       "      <td>20140702T000000</td>\n",
       "      <td>265000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1940</td>\n",
       "      <td>8170</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1940</td>\n",
       "      <td>0</td>\n",
       "      <td>1948</td>\n",
       "      <td>0</td>\n",
       "      <td>98155</td>\n",
       "      <td>47.7381</td>\n",
       "      <td>-122.302</td>\n",
       "      <td>1310</td>\n",
       "      <td>8169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8861700030</th>\n",
       "      <td>1589</td>\n",
       "      <td>20141212T000000</td>\n",
       "      <td>510000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2400</td>\n",
       "      <td>10275</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1540</td>\n",
       "      <td>860</td>\n",
       "      <td>1964</td>\n",
       "      <td>0</td>\n",
       "      <td>98052</td>\n",
       "      <td>47.6888</td>\n",
       "      <td>-122.126</td>\n",
       "      <td>2380</td>\n",
       "      <td>10125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3303980210</th>\n",
       "      <td>3317</td>\n",
       "      <td>20150427T000000</td>\n",
       "      <td>1115000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>3.75</td>\n",
       "      <td>4040</td>\n",
       "      <td>14212</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>4040</td>\n",
       "      <td>0</td>\n",
       "      <td>2002</td>\n",
       "      <td>0</td>\n",
       "      <td>98059</td>\n",
       "      <td>47.5189</td>\n",
       "      <td>-122.147</td>\n",
       "      <td>3940</td>\n",
       "      <td>14212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7731100066</th>\n",
       "      <td>2260</td>\n",
       "      <td>20140612T000000</td>\n",
       "      <td>545000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1510</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1510</td>\n",
       "      <td>0</td>\n",
       "      <td>1909</td>\n",
       "      <td>0</td>\n",
       "      <td>98105</td>\n",
       "      <td>47.6708</td>\n",
       "      <td>-122.297</td>\n",
       "      <td>1680</td>\n",
       "      <td>4000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8146100580</th>\n",
       "      <td>1727</td>\n",
       "      <td>20141020T000000</td>\n",
       "      <td>765000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1220</td>\n",
       "      <td>7585</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1220</td>\n",
       "      <td>0</td>\n",
       "      <td>1954</td>\n",
       "      <td>0</td>\n",
       "      <td>98004</td>\n",
       "      <td>47.6094</td>\n",
       "      <td>-122.194</td>\n",
       "      <td>1380</td>\n",
       "      <td>8918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825069097</th>\n",
       "      <td>1764</td>\n",
       "      <td>20140619T000000</td>\n",
       "      <td>770000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2650</td>\n",
       "      <td>40705</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>2650</td>\n",
       "      <td>0</td>\n",
       "      <td>1994</td>\n",
       "      <td>0</td>\n",
       "      <td>98053</td>\n",
       "      <td>47.6680</td>\n",
       "      <td>-122.063</td>\n",
       "      <td>2550</td>\n",
       "      <td>42625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3889100029</th>\n",
       "      <td>1611</td>\n",
       "      <td>20140617T000000</td>\n",
       "      <td>810000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2670</td>\n",
       "      <td>10481</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>2670</td>\n",
       "      <td>0</td>\n",
       "      <td>2003</td>\n",
       "      <td>0</td>\n",
       "      <td>98033</td>\n",
       "      <td>47.6673</td>\n",
       "      <td>-122.176</td>\n",
       "      <td>2620</td>\n",
       "      <td>8895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9524100196</th>\n",
       "      <td>1474</td>\n",
       "      <td>20141117T000000</td>\n",
       "      <td>239000.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1.50</td>\n",
       "      <td>680</td>\n",
       "      <td>772</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>680</td>\n",
       "      <td>0</td>\n",
       "      <td>2005</td>\n",
       "      <td>0</td>\n",
       "      <td>98103</td>\n",
       "      <td>47.6950</td>\n",
       "      <td>-122.343</td>\n",
       "      <td>690</td>\n",
       "      <td>1059</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            client_id             date      price  bedrooms  bathrooms  \\\n",
       "house_id                                                                 \n",
       "8965450190       1459  20150218T000000   295000.0         3       2.50   \n",
       "6823100225       4684  20150414T000000   700000.0         4       1.75   \n",
       "5104540330       3498  20150508T000000   679000.0         4       2.50   \n",
       "2131701075       3942  20141204T000000   420000.0         3       1.75   \n",
       "1522700060       4535  20140624T000000   518000.0         4       2.75   \n",
       "1189000207       2308  20141021T000000   387000.0         2       2.50   \n",
       "6821600300       2866  20150318T000000   886000.0         3       2.25   \n",
       "7137950720       2765  20150304T000000   339100.0         4       2.50   \n",
       "9510920050       1472  20140902T000000   725000.0         3       2.50   \n",
       "6131600255       4236  20141222T000000   202500.0         3       2.00   \n",
       "5428000070       2295  20150511T000000   770000.0         5       3.50   \n",
       "1788800910        939  20141020T000000   190000.0         3       1.00   \n",
       "8100400160       3840  20150413T000000   700000.0         3       2.25   \n",
       "3123049142        280  20140805T000000   452000.0         3       2.25   \n",
       "6306800010         20  20140811T000000   436472.0         4       2.50   \n",
       "5083000375       4332  20141027T000000   170000.0         3       1.00   \n",
       "5083000375       4332  20150319T000000   235000.0         3       1.00   \n",
       "7920100025       3475  20150427T000000   450000.0         2       1.00   \n",
       "1951600150       4213  20150408T000000   180000.0         3       1.00   \n",
       "809001400        3113  20140922T000000   925000.0         3       1.00   \n",
       "339600110        4809  20140923T000000   395000.0         3       2.50   \n",
       "1622049154       2134  20141215T000000   289900.0         3       1.75   \n",
       "1099600250       2242  20141202T000000   260000.0         3       1.75   \n",
       "8563000110       2068  20150424T000000   427000.0         4       1.75   \n",
       "2768100205       4929  20140625T000000   519000.0         4       2.50   \n",
       "3995700435       1384  20140702T000000   265000.0         4       3.00   \n",
       "8861700030       1589  20141212T000000   510000.0         3       1.50   \n",
       "3303980210       3317  20150427T000000  1115000.0         4       3.75   \n",
       "7731100066       2260  20140612T000000   545000.0         3       1.00   \n",
       "8146100580       1727  20141020T000000   765000.0         3       1.00   \n",
       "825069097        1764  20140619T000000   770000.0         3       2.50   \n",
       "3889100029       1611  20140617T000000   810000.0         3       2.50   \n",
       "9524100196       1474  20141117T000000   239000.0         2       1.50   \n",
       "\n",
       "            sqft_living  sqft_lot  floors  waterfront  view  ...  grade  \\\n",
       "house_id                                                     ...          \n",
       "8965450190         1500      3060     2.0           0     0  ...      7   \n",
       "6823100225         1870      6000     1.0           0     0  ...      8   \n",
       "5104540330         3680      7236     2.0           0     0  ...     10   \n",
       "2131701075         1720      5000     1.5           0     0  ...      8   \n",
       "1522700060         2520     14021     2.0           0     0  ...      9   \n",
       "1189000207         1170      1394     2.0           0     0  ...      8   \n",
       "6821600300         2380      6000     2.0           0     0  ...      9   \n",
       "7137950720         2350     10655     2.0           0     0  ...      8   \n",
       "9510920050         2980     16996     2.0           0     0  ...     10   \n",
       "6131600255         1540      8316     1.0           0     0  ...      6   \n",
       "5428000070         4750      8234     2.0           0     2  ...     10   \n",
       "1788800910         1200     10458     1.0           0     0  ...      6   \n",
       "8100400160         2330     11424     2.0           0     0  ...      8   \n",
       "3123049142         2600     14810     1.0           0     2  ...      8   \n",
       "6306800010         2692      8392     2.0           0     0  ...      9   \n",
       "5083000375         1310      9529     1.0           0     0  ...      7   \n",
       "5083000375         1310      9529     1.0           0     0  ...      7   \n",
       "7920100025          740      5100     1.0           0     0  ...      7   \n",
       "1951600150         1610      8500     1.5           0     0  ...      7   \n",
       "809001400          1630      3200     1.5           0     0  ...      8   \n",
       "339600110          1610      3755     2.0           0     0  ...      7   \n",
       "1622049154         1899     11325     2.0           0     0  ...      7   \n",
       "1099600250         1710      6400     1.0           0     0  ...      7   \n",
       "8563000110         1460      9750     1.0           0     0  ...      7   \n",
       "2768100205         1950      2617     1.5           0     0  ...      7   \n",
       "3995700435         1940      8170     1.0           0     0  ...      7   \n",
       "8861700030         2400     10275     1.0           0     0  ...      8   \n",
       "3303980210         4040     14212     2.0           0     0  ...     11   \n",
       "7731100066         1510      5000     1.5           0     0  ...      7   \n",
       "8146100580         1220      7585     1.0           0     0  ...      7   \n",
       "825069097          2650     40705     2.0           0     0  ...      9   \n",
       "3889100029         2670     10481     2.0           0     0  ...      9   \n",
       "9524100196          680       772     2.0           0     0  ...      7   \n",
       "\n",
       "            sqft_above  sqft_basement  yr_built  yr_renovated  zipcode  \\\n",
       "house_id                                                                 \n",
       "8965450190        1500              0      1994             0    98006   \n",
       "6823100225        1670            200      1949             0    98199   \n",
       "5104540330        3680              0      2006             0    98038   \n",
       "2131701075        1720              0      1932          2009    98019   \n",
       "1522700060        2520              0      1999             0    98019   \n",
       "1189000207        1170              0      2001             0    98122   \n",
       "6821600300        1650            730      1931             0    98199   \n",
       "7137950720        2350              0      1992             0    98092   \n",
       "9510920050        2980              0      1992             0    98075   \n",
       "6131600255        1540              0      1954             0    98002   \n",
       "5428000070        3350           1400      2013             0    98198   \n",
       "1788800910        1200              0      1961             0    98023   \n",
       "8100400160        2330              0      1984             0    98052   \n",
       "3123049142        1490           1110      1956             0    98166   \n",
       "6306800010        2692              0      2014             0    98030   \n",
       "5083000375        1310              0      1956             0    98198   \n",
       "5083000375        1310              0      1956             0    98198   \n",
       "7920100025         740              0      1947             0    98115   \n",
       "1951600150        1610              0      1959             0    98032   \n",
       "809001400         1630              0      1912             0    98109   \n",
       "339600110         1610              0      1987             0    98052   \n",
       "1622049154        1899              0      1943          2005    98198   \n",
       "1099600250        1240            470      1976             0    98023   \n",
       "8563000110        1460              0      1967             0    98008   \n",
       "2768100205        1250            700      1910             0    98107   \n",
       "3995700435        1940              0      1948             0    98155   \n",
       "8861700030        1540            860      1964             0    98052   \n",
       "3303980210        4040              0      2002             0    98059   \n",
       "7731100066        1510              0      1909             0    98105   \n",
       "8146100580        1220              0      1954             0    98004   \n",
       "825069097         2650              0      1994             0    98053   \n",
       "3889100029        2670              0      2003             0    98033   \n",
       "9524100196         680              0      2005             0    98103   \n",
       "\n",
       "                lat     long  sqft_living15  sqft_lot15  \n",
       "house_id                                                 \n",
       "8965450190  47.5605 -122.117           2700        7734  \n",
       "6823100225  47.6435 -122.399           1710        6000  \n",
       "5104540330  47.3543 -122.005           3310        7180  \n",
       "2131701075  47.7380 -121.983           1410        8300  \n",
       "1522700060  47.7344 -121.957           2330       14007  \n",
       "1189000207  47.6131 -122.297           1250        3136  \n",
       "6821600300  47.6472 -122.393           2000        6000  \n",
       "7137950720  47.3284 -122.171           2210        7028  \n",
       "9510920050  47.5950 -122.016           2980       15438  \n",
       "6131600255  47.3230 -122.216           1250        8316  \n",
       "5428000070  47.3574 -122.318           2160       14496  \n",
       "1788800910  47.3262 -122.342           1160        9000  \n",
       "8100400160  47.6386 -122.110           2050       11448  \n",
       "3123049142  47.4326 -122.341           2450       16715  \n",
       "6306800010  47.3519 -122.197           2574       14446  \n",
       "5083000375  47.4105 -122.295           1330        9529  \n",
       "5083000375  47.4105 -122.295           1330        9529  \n",
       "7920100025  47.6787 -122.301            920        5100  \n",
       "1951600150  47.3717 -122.297           1070        8750  \n",
       "809001400   47.6351 -122.352           1710        3600  \n",
       "339600110   47.6825 -122.097           1300        3823  \n",
       "1622049154  47.3987 -122.300           2000       10454  \n",
       "1099600250  47.3036 -122.377           1600        6400  \n",
       "8563000110  47.6205 -122.102           1820        9840  \n",
       "2768100205  47.6696 -122.372           1520        1438  \n",
       "3995700435  47.7381 -122.302           1310        8169  \n",
       "8861700030  47.6888 -122.126           2380       10125  \n",
       "3303980210  47.5189 -122.147           3940       14212  \n",
       "7731100066  47.6708 -122.297           1680        4000  \n",
       "8146100580  47.6094 -122.194           1380        8918  \n",
       "825069097   47.6680 -122.063           2550       42625  \n",
       "3889100029  47.6673 -122.176           2620        8895  \n",
       "9524100196  47.6950 -122.343            690        1059  \n",
       "\n",
       "[33 rows x 21 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Создаем индексы с помощью метода set_index для каждого DataFrame, по которым будет происходить слияние\n",
    "clients_house_id = clients.set_index('house_id')\n",
    "df_idx = df.set_index('id')\n",
    "\n",
    "joined = clients_house_id.join(df_idx)\n",
    "joined"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Присоедините к таблице clients данные по домам через метод merge и сохраните в merged.\n",
    "\n",
    "Это нужно, чтобы понимать, какие дома покупались клиентами.\n",
    "\n",
    "house_id - это индексы датафрейма с домами."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>client_id</th>\n",
       "      <th>house_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>bathrooms</th>\n",
       "      <th>sqft_living</th>\n",
       "      <th>sqft_lot</th>\n",
       "      <th>floors</th>\n",
       "      <th>...</th>\n",
       "      <th>grade</th>\n",
       "      <th>sqft_above</th>\n",
       "      <th>sqft_basement</th>\n",
       "      <th>yr_built</th>\n",
       "      <th>yr_renovated</th>\n",
       "      <th>zipcode</th>\n",
       "      <th>lat</th>\n",
       "      <th>long</th>\n",
       "      <th>sqft_living15</th>\n",
       "      <th>sqft_lot15</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1459</td>\n",
       "      <td>8965450190</td>\n",
       "      <td>8965450190</td>\n",
       "      <td>20150218T000000</td>\n",
       "      <td>295000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1500</td>\n",
       "      <td>3060</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1500</td>\n",
       "      <td>0</td>\n",
       "      <td>1994</td>\n",
       "      <td>0</td>\n",
       "      <td>98006</td>\n",
       "      <td>47.5605</td>\n",
       "      <td>-122.117</td>\n",
       "      <td>2700</td>\n",
       "      <td>7734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4684</td>\n",
       "      <td>6823100225</td>\n",
       "      <td>6823100225</td>\n",
       "      <td>20150414T000000</td>\n",
       "      <td>700000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1870</td>\n",
       "      <td>6000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1670</td>\n",
       "      <td>200</td>\n",
       "      <td>1949</td>\n",
       "      <td>0</td>\n",
       "      <td>98199</td>\n",
       "      <td>47.6435</td>\n",
       "      <td>-122.399</td>\n",
       "      <td>1710</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3498</td>\n",
       "      <td>5104540330</td>\n",
       "      <td>5104540330</td>\n",
       "      <td>20150508T000000</td>\n",
       "      <td>679000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.50</td>\n",
       "      <td>3680</td>\n",
       "      <td>7236</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>3680</td>\n",
       "      <td>0</td>\n",
       "      <td>2006</td>\n",
       "      <td>0</td>\n",
       "      <td>98038</td>\n",
       "      <td>47.3543</td>\n",
       "      <td>-122.005</td>\n",
       "      <td>3310</td>\n",
       "      <td>7180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3942</td>\n",
       "      <td>2131701075</td>\n",
       "      <td>2131701075</td>\n",
       "      <td>20141204T000000</td>\n",
       "      <td>420000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1720</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1720</td>\n",
       "      <td>0</td>\n",
       "      <td>1932</td>\n",
       "      <td>2009</td>\n",
       "      <td>98019</td>\n",
       "      <td>47.7380</td>\n",
       "      <td>-121.983</td>\n",
       "      <td>1410</td>\n",
       "      <td>8300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4535</td>\n",
       "      <td>1522700060</td>\n",
       "      <td>1522700060</td>\n",
       "      <td>20140624T000000</td>\n",
       "      <td>518000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.75</td>\n",
       "      <td>2520</td>\n",
       "      <td>14021</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>2520</td>\n",
       "      <td>0</td>\n",
       "      <td>1999</td>\n",
       "      <td>0</td>\n",
       "      <td>98019</td>\n",
       "      <td>47.7344</td>\n",
       "      <td>-121.957</td>\n",
       "      <td>2330</td>\n",
       "      <td>14007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2308</td>\n",
       "      <td>1189000207</td>\n",
       "      <td>1189000207</td>\n",
       "      <td>20141021T000000</td>\n",
       "      <td>387000.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1170</td>\n",
       "      <td>1394</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1170</td>\n",
       "      <td>0</td>\n",
       "      <td>2001</td>\n",
       "      <td>0</td>\n",
       "      <td>98122</td>\n",
       "      <td>47.6131</td>\n",
       "      <td>-122.297</td>\n",
       "      <td>1250</td>\n",
       "      <td>3136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2866</td>\n",
       "      <td>6821600300</td>\n",
       "      <td>6821600300</td>\n",
       "      <td>20150318T000000</td>\n",
       "      <td>886000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.25</td>\n",
       "      <td>2380</td>\n",
       "      <td>6000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>1650</td>\n",
       "      <td>730</td>\n",
       "      <td>1931</td>\n",
       "      <td>0</td>\n",
       "      <td>98199</td>\n",
       "      <td>47.6472</td>\n",
       "      <td>-122.393</td>\n",
       "      <td>2000</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2765</td>\n",
       "      <td>7137950720</td>\n",
       "      <td>7137950720</td>\n",
       "      <td>20150304T000000</td>\n",
       "      <td>339100.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2350</td>\n",
       "      <td>10655</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>2350</td>\n",
       "      <td>0</td>\n",
       "      <td>1992</td>\n",
       "      <td>0</td>\n",
       "      <td>98092</td>\n",
       "      <td>47.3284</td>\n",
       "      <td>-122.171</td>\n",
       "      <td>2210</td>\n",
       "      <td>7028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1472</td>\n",
       "      <td>9510920050</td>\n",
       "      <td>9510920050</td>\n",
       "      <td>20140902T000000</td>\n",
       "      <td>725000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2980</td>\n",
       "      <td>16996</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>2980</td>\n",
       "      <td>0</td>\n",
       "      <td>1992</td>\n",
       "      <td>0</td>\n",
       "      <td>98075</td>\n",
       "      <td>47.5950</td>\n",
       "      <td>-122.016</td>\n",
       "      <td>2980</td>\n",
       "      <td>15438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4236</td>\n",
       "      <td>6131600255</td>\n",
       "      <td>6131600255</td>\n",
       "      <td>20141222T000000</td>\n",
       "      <td>202500.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1540</td>\n",
       "      <td>8316</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1540</td>\n",
       "      <td>0</td>\n",
       "      <td>1954</td>\n",
       "      <td>0</td>\n",
       "      <td>98002</td>\n",
       "      <td>47.3230</td>\n",
       "      <td>-122.216</td>\n",
       "      <td>1250</td>\n",
       "      <td>8316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2295</td>\n",
       "      <td>5428000070</td>\n",
       "      <td>5428000070</td>\n",
       "      <td>20150511T000000</td>\n",
       "      <td>770000.0</td>\n",
       "      <td>5</td>\n",
       "      <td>3.50</td>\n",
       "      <td>4750</td>\n",
       "      <td>8234</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>3350</td>\n",
       "      <td>1400</td>\n",
       "      <td>2013</td>\n",
       "      <td>0</td>\n",
       "      <td>98198</td>\n",
       "      <td>47.3574</td>\n",
       "      <td>-122.318</td>\n",
       "      <td>2160</td>\n",
       "      <td>14496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>939</td>\n",
       "      <td>1788800910</td>\n",
       "      <td>1788800910</td>\n",
       "      <td>20141020T000000</td>\n",
       "      <td>190000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1200</td>\n",
       "      <td>10458</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>1200</td>\n",
       "      <td>0</td>\n",
       "      <td>1961</td>\n",
       "      <td>0</td>\n",
       "      <td>98023</td>\n",
       "      <td>47.3262</td>\n",
       "      <td>-122.342</td>\n",
       "      <td>1160</td>\n",
       "      <td>9000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3840</td>\n",
       "      <td>8100400160</td>\n",
       "      <td>8100400160</td>\n",
       "      <td>20150413T000000</td>\n",
       "      <td>700000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.25</td>\n",
       "      <td>2330</td>\n",
       "      <td>11424</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>2330</td>\n",
       "      <td>0</td>\n",
       "      <td>1984</td>\n",
       "      <td>0</td>\n",
       "      <td>98052</td>\n",
       "      <td>47.6386</td>\n",
       "      <td>-122.110</td>\n",
       "      <td>2050</td>\n",
       "      <td>11448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>280</td>\n",
       "      <td>3123049142</td>\n",
       "      <td>3123049142</td>\n",
       "      <td>20140805T000000</td>\n",
       "      <td>452000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.25</td>\n",
       "      <td>2600</td>\n",
       "      <td>14810</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1490</td>\n",
       "      <td>1110</td>\n",
       "      <td>1956</td>\n",
       "      <td>0</td>\n",
       "      <td>98166</td>\n",
       "      <td>47.4326</td>\n",
       "      <td>-122.341</td>\n",
       "      <td>2450</td>\n",
       "      <td>16715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>20</td>\n",
       "      <td>6306800010</td>\n",
       "      <td>6306800010</td>\n",
       "      <td>20140811T000000</td>\n",
       "      <td>436472.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2692</td>\n",
       "      <td>8392</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>2692</td>\n",
       "      <td>0</td>\n",
       "      <td>2014</td>\n",
       "      <td>0</td>\n",
       "      <td>98030</td>\n",
       "      <td>47.3519</td>\n",
       "      <td>-122.197</td>\n",
       "      <td>2574</td>\n",
       "      <td>14446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4332</td>\n",
       "      <td>5083000375</td>\n",
       "      <td>5083000375</td>\n",
       "      <td>20141027T000000</td>\n",
       "      <td>170000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1310</td>\n",
       "      <td>9529</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1310</td>\n",
       "      <td>0</td>\n",
       "      <td>1956</td>\n",
       "      <td>0</td>\n",
       "      <td>98198</td>\n",
       "      <td>47.4105</td>\n",
       "      <td>-122.295</td>\n",
       "      <td>1330</td>\n",
       "      <td>9529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>4332</td>\n",
       "      <td>5083000375</td>\n",
       "      <td>5083000375</td>\n",
       "      <td>20150319T000000</td>\n",
       "      <td>235000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1310</td>\n",
       "      <td>9529</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1310</td>\n",
       "      <td>0</td>\n",
       "      <td>1956</td>\n",
       "      <td>0</td>\n",
       "      <td>98198</td>\n",
       "      <td>47.4105</td>\n",
       "      <td>-122.295</td>\n",
       "      <td>1330</td>\n",
       "      <td>9529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3475</td>\n",
       "      <td>7920100025</td>\n",
       "      <td>7920100025</td>\n",
       "      <td>20150427T000000</td>\n",
       "      <td>450000.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1.00</td>\n",
       "      <td>740</td>\n",
       "      <td>5100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>740</td>\n",
       "      <td>0</td>\n",
       "      <td>1947</td>\n",
       "      <td>0</td>\n",
       "      <td>98115</td>\n",
       "      <td>47.6787</td>\n",
       "      <td>-122.301</td>\n",
       "      <td>920</td>\n",
       "      <td>5100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4213</td>\n",
       "      <td>1951600150</td>\n",
       "      <td>1951600150</td>\n",
       "      <td>20150408T000000</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1610</td>\n",
       "      <td>8500</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1610</td>\n",
       "      <td>0</td>\n",
       "      <td>1959</td>\n",
       "      <td>0</td>\n",
       "      <td>98032</td>\n",
       "      <td>47.3717</td>\n",
       "      <td>-122.297</td>\n",
       "      <td>1070</td>\n",
       "      <td>8750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>3113</td>\n",
       "      <td>809001400</td>\n",
       "      <td>809001400</td>\n",
       "      <td>20140922T000000</td>\n",
       "      <td>925000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1630</td>\n",
       "      <td>3200</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1630</td>\n",
       "      <td>0</td>\n",
       "      <td>1912</td>\n",
       "      <td>0</td>\n",
       "      <td>98109</td>\n",
       "      <td>47.6351</td>\n",
       "      <td>-122.352</td>\n",
       "      <td>1710</td>\n",
       "      <td>3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>4809</td>\n",
       "      <td>339600110</td>\n",
       "      <td>339600110</td>\n",
       "      <td>20140923T000000</td>\n",
       "      <td>395000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1610</td>\n",
       "      <td>3755</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1610</td>\n",
       "      <td>0</td>\n",
       "      <td>1987</td>\n",
       "      <td>0</td>\n",
       "      <td>98052</td>\n",
       "      <td>47.6825</td>\n",
       "      <td>-122.097</td>\n",
       "      <td>1300</td>\n",
       "      <td>3823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2134</td>\n",
       "      <td>1622049154</td>\n",
       "      <td>1622049154</td>\n",
       "      <td>20141215T000000</td>\n",
       "      <td>289900.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1899</td>\n",
       "      <td>11325</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1899</td>\n",
       "      <td>0</td>\n",
       "      <td>1943</td>\n",
       "      <td>2005</td>\n",
       "      <td>98198</td>\n",
       "      <td>47.3987</td>\n",
       "      <td>-122.300</td>\n",
       "      <td>2000</td>\n",
       "      <td>10454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2242</td>\n",
       "      <td>1099600250</td>\n",
       "      <td>1099600250</td>\n",
       "      <td>20141202T000000</td>\n",
       "      <td>260000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1710</td>\n",
       "      <td>6400</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1240</td>\n",
       "      <td>470</td>\n",
       "      <td>1976</td>\n",
       "      <td>0</td>\n",
       "      <td>98023</td>\n",
       "      <td>47.3036</td>\n",
       "      <td>-122.377</td>\n",
       "      <td>1600</td>\n",
       "      <td>6400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2068</td>\n",
       "      <td>8563000110</td>\n",
       "      <td>8563000110</td>\n",
       "      <td>20150424T000000</td>\n",
       "      <td>427000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1460</td>\n",
       "      <td>9750</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1460</td>\n",
       "      <td>0</td>\n",
       "      <td>1967</td>\n",
       "      <td>0</td>\n",
       "      <td>98008</td>\n",
       "      <td>47.6205</td>\n",
       "      <td>-122.102</td>\n",
       "      <td>1820</td>\n",
       "      <td>9840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>4929</td>\n",
       "      <td>2768100205</td>\n",
       "      <td>2768100205</td>\n",
       "      <td>20140625T000000</td>\n",
       "      <td>519000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1950</td>\n",
       "      <td>2617</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1250</td>\n",
       "      <td>700</td>\n",
       "      <td>1910</td>\n",
       "      <td>0</td>\n",
       "      <td>98107</td>\n",
       "      <td>47.6696</td>\n",
       "      <td>-122.372</td>\n",
       "      <td>1520</td>\n",
       "      <td>1438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1384</td>\n",
       "      <td>3995700435</td>\n",
       "      <td>3995700435</td>\n",
       "      <td>20140702T000000</td>\n",
       "      <td>265000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1940</td>\n",
       "      <td>8170</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1940</td>\n",
       "      <td>0</td>\n",
       "      <td>1948</td>\n",
       "      <td>0</td>\n",
       "      <td>98155</td>\n",
       "      <td>47.7381</td>\n",
       "      <td>-122.302</td>\n",
       "      <td>1310</td>\n",
       "      <td>8169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1589</td>\n",
       "      <td>8861700030</td>\n",
       "      <td>8861700030</td>\n",
       "      <td>20141212T000000</td>\n",
       "      <td>510000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2400</td>\n",
       "      <td>10275</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>1540</td>\n",
       "      <td>860</td>\n",
       "      <td>1964</td>\n",
       "      <td>0</td>\n",
       "      <td>98052</td>\n",
       "      <td>47.6888</td>\n",
       "      <td>-122.126</td>\n",
       "      <td>2380</td>\n",
       "      <td>10125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3317</td>\n",
       "      <td>3303980210</td>\n",
       "      <td>3303980210</td>\n",
       "      <td>20150427T000000</td>\n",
       "      <td>1115000.0</td>\n",
       "      <td>4</td>\n",
       "      <td>3.75</td>\n",
       "      <td>4040</td>\n",
       "      <td>14212</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>4040</td>\n",
       "      <td>0</td>\n",
       "      <td>2002</td>\n",
       "      <td>0</td>\n",
       "      <td>98059</td>\n",
       "      <td>47.5189</td>\n",
       "      <td>-122.147</td>\n",
       "      <td>3940</td>\n",
       "      <td>14212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2260</td>\n",
       "      <td>7731100066</td>\n",
       "      <td>7731100066</td>\n",
       "      <td>20140612T000000</td>\n",
       "      <td>545000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1510</td>\n",
       "      <td>5000</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1510</td>\n",
       "      <td>0</td>\n",
       "      <td>1909</td>\n",
       "      <td>0</td>\n",
       "      <td>98105</td>\n",
       "      <td>47.6708</td>\n",
       "      <td>-122.297</td>\n",
       "      <td>1680</td>\n",
       "      <td>4000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1727</td>\n",
       "      <td>8146100580</td>\n",
       "      <td>8146100580</td>\n",
       "      <td>20141020T000000</td>\n",
       "      <td>765000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1220</td>\n",
       "      <td>7585</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>1220</td>\n",
       "      <td>0</td>\n",
       "      <td>1954</td>\n",
       "      <td>0</td>\n",
       "      <td>98004</td>\n",
       "      <td>47.6094</td>\n",
       "      <td>-122.194</td>\n",
       "      <td>1380</td>\n",
       "      <td>8918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1764</td>\n",
       "      <td>825069097</td>\n",
       "      <td>825069097</td>\n",
       "      <td>20140619T000000</td>\n",
       "      <td>770000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2650</td>\n",
       "      <td>40705</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>2650</td>\n",
       "      <td>0</td>\n",
       "      <td>1994</td>\n",
       "      <td>0</td>\n",
       "      <td>98053</td>\n",
       "      <td>47.6680</td>\n",
       "      <td>-122.063</td>\n",
       "      <td>2550</td>\n",
       "      <td>42625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1611</td>\n",
       "      <td>3889100029</td>\n",
       "      <td>3889100029</td>\n",
       "      <td>20140617T000000</td>\n",
       "      <td>810000.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2670</td>\n",
       "      <td>10481</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>2670</td>\n",
       "      <td>0</td>\n",
       "      <td>2003</td>\n",
       "      <td>0</td>\n",
       "      <td>98033</td>\n",
       "      <td>47.6673</td>\n",
       "      <td>-122.176</td>\n",
       "      <td>2620</td>\n",
       "      <td>8895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1474</td>\n",
       "      <td>9524100196</td>\n",
       "      <td>9524100196</td>\n",
       "      <td>20141117T000000</td>\n",
       "      <td>239000.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1.50</td>\n",
       "      <td>680</td>\n",
       "      <td>772</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>680</td>\n",
       "      <td>0</td>\n",
       "      <td>2005</td>\n",
       "      <td>0</td>\n",
       "      <td>98103</td>\n",
       "      <td>47.6950</td>\n",
       "      <td>-122.343</td>\n",
       "      <td>690</td>\n",
       "      <td>1059</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    client_id    house_id          id             date      price  bedrooms  \\\n",
       "0        1459  8965450190  8965450190  20150218T000000   295000.0         3   \n",
       "1        4684  6823100225  6823100225  20150414T000000   700000.0         4   \n",
       "2        3498  5104540330  5104540330  20150508T000000   679000.0         4   \n",
       "3        3942  2131701075  2131701075  20141204T000000   420000.0         3   \n",
       "4        4535  1522700060  1522700060  20140624T000000   518000.0         4   \n",
       "5        2308  1189000207  1189000207  20141021T000000   387000.0         2   \n",
       "6        2866  6821600300  6821600300  20150318T000000   886000.0         3   \n",
       "7        2765  7137950720  7137950720  20150304T000000   339100.0         4   \n",
       "8        1472  9510920050  9510920050  20140902T000000   725000.0         3   \n",
       "9        4236  6131600255  6131600255  20141222T000000   202500.0         3   \n",
       "10       2295  5428000070  5428000070  20150511T000000   770000.0         5   \n",
       "11        939  1788800910  1788800910  20141020T000000   190000.0         3   \n",
       "12       3840  8100400160  8100400160  20150413T000000   700000.0         3   \n",
       "13        280  3123049142  3123049142  20140805T000000   452000.0         3   \n",
       "14         20  6306800010  6306800010  20140811T000000   436472.0         4   \n",
       "15       4332  5083000375  5083000375  20141027T000000   170000.0         3   \n",
       "16       4332  5083000375  5083000375  20150319T000000   235000.0         3   \n",
       "17       3475  7920100025  7920100025  20150427T000000   450000.0         2   \n",
       "18       4213  1951600150  1951600150  20150408T000000   180000.0         3   \n",
       "19       3113   809001400   809001400  20140922T000000   925000.0         3   \n",
       "20       4809   339600110   339600110  20140923T000000   395000.0         3   \n",
       "21       2134  1622049154  1622049154  20141215T000000   289900.0         3   \n",
       "22       2242  1099600250  1099600250  20141202T000000   260000.0         3   \n",
       "23       2068  8563000110  8563000110  20150424T000000   427000.0         4   \n",
       "24       4929  2768100205  2768100205  20140625T000000   519000.0         4   \n",
       "25       1384  3995700435  3995700435  20140702T000000   265000.0         4   \n",
       "26       1589  8861700030  8861700030  20141212T000000   510000.0         3   \n",
       "27       3317  3303980210  3303980210  20150427T000000  1115000.0         4   \n",
       "28       2260  7731100066  7731100066  20140612T000000   545000.0         3   \n",
       "29       1727  8146100580  8146100580  20141020T000000   765000.0         3   \n",
       "30       1764   825069097   825069097  20140619T000000   770000.0         3   \n",
       "31       1611  3889100029  3889100029  20140617T000000   810000.0         3   \n",
       "32       1474  9524100196  9524100196  20141117T000000   239000.0         2   \n",
       "\n",
       "    bathrooms  sqft_living  sqft_lot  floors  ...  grade  sqft_above  \\\n",
       "0        2.50         1500      3060     2.0  ...      7        1500   \n",
       "1        1.75         1870      6000     1.0  ...      8        1670   \n",
       "2        2.50         3680      7236     2.0  ...     10        3680   \n",
       "3        1.75         1720      5000     1.5  ...      8        1720   \n",
       "4        2.75         2520     14021     2.0  ...      9        2520   \n",
       "5        2.50         1170      1394     2.0  ...      8        1170   \n",
       "6        2.25         2380      6000     2.0  ...      9        1650   \n",
       "7        2.50         2350     10655     2.0  ...      8        2350   \n",
       "8        2.50         2980     16996     2.0  ...     10        2980   \n",
       "9        2.00         1540      8316     1.0  ...      6        1540   \n",
       "10       3.50         4750      8234     2.0  ...     10        3350   \n",
       "11       1.00         1200     10458     1.0  ...      6        1200   \n",
       "12       2.25         2330     11424     2.0  ...      8        2330   \n",
       "13       2.25         2600     14810     1.0  ...      8        1490   \n",
       "14       2.50         2692      8392     2.0  ...      9        2692   \n",
       "15       1.00         1310      9529     1.0  ...      7        1310   \n",
       "16       1.00         1310      9529     1.0  ...      7        1310   \n",
       "17       1.00          740      5100     1.0  ...      7         740   \n",
       "18       1.00         1610      8500     1.5  ...      7        1610   \n",
       "19       1.00         1630      3200     1.5  ...      8        1630   \n",
       "20       2.50         1610      3755     2.0  ...      7        1610   \n",
       "21       1.75         1899     11325     2.0  ...      7        1899   \n",
       "22       1.75         1710      6400     1.0  ...      7        1240   \n",
       "23       1.75         1460      9750     1.0  ...      7        1460   \n",
       "24       2.50         1950      2617     1.5  ...      7        1250   \n",
       "25       3.00         1940      8170     1.0  ...      7        1940   \n",
       "26       1.50         2400     10275     1.0  ...      8        1540   \n",
       "27       3.75         4040     14212     2.0  ...     11        4040   \n",
       "28       1.00         1510      5000     1.5  ...      7        1510   \n",
       "29       1.00         1220      7585     1.0  ...      7        1220   \n",
       "30       2.50         2650     40705     2.0  ...      9        2650   \n",
       "31       2.50         2670     10481     2.0  ...      9        2670   \n",
       "32       1.50          680       772     2.0  ...      7         680   \n",
       "\n",
       "    sqft_basement  yr_built  yr_renovated  zipcode      lat     long  \\\n",
       "0               0      1994             0    98006  47.5605 -122.117   \n",
       "1             200      1949             0    98199  47.6435 -122.399   \n",
       "2               0      2006             0    98038  47.3543 -122.005   \n",
       "3               0      1932          2009    98019  47.7380 -121.983   \n",
       "4               0      1999             0    98019  47.7344 -121.957   \n",
       "5               0      2001             0    98122  47.6131 -122.297   \n",
       "6             730      1931             0    98199  47.6472 -122.393   \n",
       "7               0      1992             0    98092  47.3284 -122.171   \n",
       "8               0      1992             0    98075  47.5950 -122.016   \n",
       "9               0      1954             0    98002  47.3230 -122.216   \n",
       "10           1400      2013             0    98198  47.3574 -122.318   \n",
       "11              0      1961             0    98023  47.3262 -122.342   \n",
       "12              0      1984             0    98052  47.6386 -122.110   \n",
       "13           1110      1956             0    98166  47.4326 -122.341   \n",
       "14              0      2014             0    98030  47.3519 -122.197   \n",
       "15              0      1956             0    98198  47.4105 -122.295   \n",
       "16              0      1956             0    98198  47.4105 -122.295   \n",
       "17              0      1947             0    98115  47.6787 -122.301   \n",
       "18              0      1959             0    98032  47.3717 -122.297   \n",
       "19              0      1912             0    98109  47.6351 -122.352   \n",
       "20              0      1987             0    98052  47.6825 -122.097   \n",
       "21              0      1943          2005    98198  47.3987 -122.300   \n",
       "22            470      1976             0    98023  47.3036 -122.377   \n",
       "23              0      1967             0    98008  47.6205 -122.102   \n",
       "24            700      1910             0    98107  47.6696 -122.372   \n",
       "25              0      1948             0    98155  47.7381 -122.302   \n",
       "26            860      1964             0    98052  47.6888 -122.126   \n",
       "27              0      2002             0    98059  47.5189 -122.147   \n",
       "28              0      1909             0    98105  47.6708 -122.297   \n",
       "29              0      1954             0    98004  47.6094 -122.194   \n",
       "30              0      1994             0    98053  47.6680 -122.063   \n",
       "31              0      2003             0    98033  47.6673 -122.176   \n",
       "32              0      2005             0    98103  47.6950 -122.343   \n",
       "\n",
       "    sqft_living15  sqft_lot15  \n",
       "0            2700        7734  \n",
       "1            1710        6000  \n",
       "2            3310        7180  \n",
       "3            1410        8300  \n",
       "4            2330       14007  \n",
       "5            1250        3136  \n",
       "6            2000        6000  \n",
       "7            2210        7028  \n",
       "8            2980       15438  \n",
       "9            1250        8316  \n",
       "10           2160       14496  \n",
       "11           1160        9000  \n",
       "12           2050       11448  \n",
       "13           2450       16715  \n",
       "14           2574       14446  \n",
       "15           1330        9529  \n",
       "16           1330        9529  \n",
       "17            920        5100  \n",
       "18           1070        8750  \n",
       "19           1710        3600  \n",
       "20           1300        3823  \n",
       "21           2000       10454  \n",
       "22           1600        6400  \n",
       "23           1820        9840  \n",
       "24           1520        1438  \n",
       "25           1310        8169  \n",
       "26           2380       10125  \n",
       "27           3940       14212  \n",
       "28           1680        4000  \n",
       "29           1380        8918  \n",
       "30           2550       42625  \n",
       "31           2620        8895  \n",
       "32            690        1059  \n",
       "\n",
       "[33 rows x 23 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged = clients.merge(df, left_on=\"house_id\", right_on=\"id\")\n",
    "merged"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
